|
10 Search Results Found |
1 |
Forum: Replication «»
Posted on: Thu, 29 March 2018 02:35 «»
By: gajini
Replication using Oracle GoldenGate.
I think using Oracle GoldenGate, We can replicate all the tables of one schema(Ex:SCOTT1) only.
Please let me know if it is possible to replicate multiple schemas(Ex:SCOTT1,SCOTT2) using Oracle GoldenGate.
|
2 |
Forum: Replication «»
Posted on: Tue, 13 March 2018 02:22 «»
By: ssumesh
Oracle Golden Gate replication
… captured as below.
SQL> select * from SCOTT1.EMP_REP060318;
TABLE_NAME INSERT_COUNT DELETE_COUNT UPDATE_COUNT
-------------------- ------------ ------------ ------------
EMP_EXT060218 1 0 1
…
|
3 |
Forum: Server Utilities «»
Posted on: Tue, 07 October 2014 14:13 «»
By: BlackSwan
Re: Tablespace and Schema info from dumpfile
…from [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD
Password key for accessing encrypted data within a dump file.
Not valid for network import jobs.
ESTIMATE
Calculate job estimates.
Valid …
|
4 |
Forum: Windows «»
Posted on: Fri, 21 March 2014 01:39 «»
By: x-oracle
how to put current date and time in dump file using expdp utility in windows
…ask u in my database i have one user name scott1 i want to take this user logical backup everyday using expdp. i know how to take schemas backup using expdp i take this user backup using this
expdp system/moon@orcl directory=practice dumpfile= …
|
5 |
Forum: Server Utilities «»
Posted on: Thu, 15 August 2013 12:07 «»
By: BlackSwan
Re: Error using parfile
…names [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION
Encrypt part or all of a dump file.
Valid keyword values are: ALL, DATA_ONLY, ENCRYPTED_COLUMNS_ONLY, METADATA_ONLY and NONE.
ENCRYPTION_ALGORITHM
…
|
6 |
Forum: Server Utilities «»
Posted on: Tue, 07 May 2013 07:20 «»
By: Michel Cadot
Re: Databaseimport error
C:\>impdp help=y
...
DUMPFILE
List of dump files to import from [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
...
See the 3rd file of the example.
regards
Michel
|
7 |
Forum: Server Utilities «»
Posted on: Thu, 23 August 2012 04:58 «»
By: Michel Cadot
Re: how to move all data from one tablespace to another tablespace
…t.dmp),
e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD Password key for accessing encrypted column data.
This parameter is not valid for network import jobs.
ESTIMATE…
|
8 |
Forum: Backup & Recovery «»
Posted on: Wed, 11 July 2012 01:30 «»
By: Michel Cadot
Re: Taking a dump of huge table
…t.dmp),
e.g. DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD Password key for creating encrypted column data.
ESTIMATE Calculate job estimates where the valid keywords are…
|
9 |
Forum: Server Utilities «»
Posted on: Sun, 15 April 2012 11:39 «»
By: BlackSwan
Re: Increasing parallel process in impdp in runtime
…from [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
ENCRYPTION_PASSWORD
Password key for accessing encrypted data within a dump file.
Not valid for network import jobs.
ESTIMATE
Calculate job estimates.
Valid …
|
10 |
Forum: RAC & Failsafe «»
Posted on: Mon, 23 January 2012 23:18 «»
By: shipon_97
Expdp/Impdp performs slow in RAC oracle11gR2
…system/sys123 directory=test_dir dumpfile=scott1.dmp schemas=scott
Export: Release 11.2.0.1.0 - Production on Mon Jan 23 09:30:26 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g…
|